Excel 2016 for Business Statistics by Thomas J. Quirk

Author:Thomas J. Quirk
Language: eng
Format: epub
Publisher: Springer International Publishing, Cham

Now, write the following sentence in D31 to D34 to summarize the result of the study:D31:Since the absolute value of −4.55

D32:is greater than the critical t of

D33:1.96, we reject the null hypothesis

D34:and accept the research hypothesis.

Finally, write the following sentence in D36 to D38 to summarize the conclusion of the study in plain English:D36:Teenage boys rated the taste of

D37:Pepsi as significantly better than

D38:the taste of Coke (64 vs. 55).

Save your file as: COKE4

Print this file so that it fits onto one page, and write by hand the null hypothesis and the research hypothesis on your printout.

The final spreadsheet appears in Fig. 5.12.

Fig. 5.12Final Worksheet for the Coke vs. Pepsi Taste Test

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.